Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_SUBSCRIBED_TABLES

`ALL_SUBSCRIBED_TABLES` describes the source tables to which any subscription accessible to the current user has subscribed. This view is intended for use by Change Data Capture subscribers.

Related Views

- `DBA_SUBSCRIBED_TABLES` describes all source tables in the database to which any subscriber has subscribed.

- `USER_SUBSCRIBED_TABLES` describes the source tables to which the current user has subscribed.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`HANDLE` | `NUMBER` | `NOT NULL` | Subscription handle
`SOURCE_SCHEMA_NAME` | `VARCHAR2(30)` | `NOT NULL` | Source table owner
`SOURCE_TABLE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Source table name
`VIEW_NAME` | `VARCHAR2(30)` |  | Subscriber view name
`CHANGE_SET_NAME` | `VARCHAR2(30)` | `NOT NULL` | Change set name
`SUBSCRIPTION_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the subscription

See Also: "DBA_SUBSCRIBED_TABLES" "USER_SUBSCRIBED_TABLES"